{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5ec3dc04",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>days</th>\n",
       "      <th>photo_nums</th>\n",
       "      <th>per_capita_fee</th>\n",
       "      <th>people</th>\n",
       "      <th>trip</th>\n",
       "      <th>road</th>\n",
       "      <th>schedule</th>\n",
       "      <th>img1</th>\n",
       "      <th>img2</th>\n",
       "      <th>img3</th>\n",
       "      <th>img4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20 出发</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>人均9000元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21 出发</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>人均5000元</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>途经：泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17 出发</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>人均6000元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>途经：成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28 出发</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27 出发</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13 出发</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>途经：杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21 出发</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>人均2300元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>途经：大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28 出发</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13 出发</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>途经：宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23 出发</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          title  author           date  days photo_nums  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道  2024-07-20 出发   共9天     201张照片   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹  2023-10-21 出发   共7天     252张照片   \n",
       "2                           川西游    mnzs  2024-07-17 出发  共10天      92张照片   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩  2024-07-28 出发  共15天     816张照片   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃  2024-07-27 出发   共7天     151张照片   \n",
       "...                         ...     ...            ...   ...        ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋  2019-07-13 出发   共5天     122张照片   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲  2019-07-21 出发   共9天      90张照片   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵  2019-02-28 出发   共1天     269张照片   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君  2019-07-13 出发   共5天     244张照片   \n",
       "1999                       游武夷山      珊珊  2016-09-23 出发   共3天      36张照片   \n",
       "\n",
       "     per_capita_fee people                      trip              road  \\\n",
       "0           人均9000元     亲子              自驾 暑假 摄影 第一次                     \n",
       "1           人均5000元     闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  途经：泰国(曼谷Bangkok)   \n",
       "2           人均6000元     家庭                  美食 自驾 暑假     途经：成都>都江堰>九寨沟   \n",
       "3               人均元     家庭                  古镇 自驾 暑假                     \n",
       "4               人均元     亲子              深度游 环游 美食 暑假                     \n",
       "...             ...    ...                       ...               ...   \n",
       "1995        人均4000元   三五好友            漫游 美食 古镇 摄影 夏季    途经：杭州>绍兴>嘉兴>湖州   \n",
       "1996        人均2300元     家庭               海滨海岛 暑假 第一次             途经：大连   \n",
       "1997            人均元     家庭                        古镇                     \n",
       "1998        人均4000元   三五好友                  自驾 暑假 摄影    途经：宁波>温州>舟山>台州   \n",
       "1999            人均元     家庭                      短途周末                     \n",
       "\n",
       "                                              schedule  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                   img1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                   img2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                   img3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                   img4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "from sqlalchemy import create_engine, text\n",
    "\n",
    "HOST = \"127.0.0.1\"\n",
    "\n",
    "PORT = 3306\n",
    "\n",
    "USER = \"root\"\n",
    "\n",
    "PASSWORD = \"123456\"\n",
    "\n",
    "DBNAME = \"travelduct\"\n",
    "\n",
    " \n",
    "\n",
    "DB_URI = f\"mysql+pymysql://{USER}:{PASSWORD}@{HOST}:{PORT}/{DBNAME}?charset=utf8\"\n",
    "\n",
    "data = pd.read_sql(\"select * from scenic_spot\",con=DB_URI)\n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "646295d2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2000 entries, 0 to 1999\n",
      "Data columns (total 14 columns):\n",
      " #   Column          Non-Null Count  Dtype \n",
      "---  ------          --------------  ----- \n",
      " 0   title           2000 non-null   object\n",
      " 1   author          2000 non-null   object\n",
      " 2   date            2000 non-null   object\n",
      " 3   days            2000 non-null   object\n",
      " 4   photo_nums      2000 non-null   object\n",
      " 5   per_capita_fee  2000 non-null   object\n",
      " 6   people          2000 non-null   object\n",
      " 7   trip            2000 non-null   object\n",
      " 8   road            2000 non-null   object\n",
      " 9   schedule        2000 non-null   object\n",
      " 10  img1            2000 non-null   object\n",
      " 11  img2            2000 non-null   object\n",
      " 12  img3            2000 non-null   object\n",
      " 13  img4            2000 non-null   object\n",
      "dtypes: object(14)\n",
      "memory usage: 218.9+ KB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9e92e109",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>标题</th>\n",
       "      <th>作者</th>\n",
       "      <th>时间</th>\n",
       "      <th>天数</th>\n",
       "      <th>照片数量</th>\n",
       "      <th>人均费用</th>\n",
       "      <th>人物</th>\n",
       "      <th>玩法</th>\n",
       "      <th>途经</th>\n",
       "      <th>行程</th>\n",
       "      <th>图1</th>\n",
       "      <th>图2</th>\n",
       "      <th>图3</th>\n",
       "      <th>图4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20 出发</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>人均9000元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21 出发</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>人均5000元</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>途经：泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17 出发</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>人均6000元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>途经：成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28 出发</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27 出发</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13 出发</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>途经：杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21 出发</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>人均2300元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>途经：大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28 出发</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13 出发</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>途经：宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23 出发</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             标题      作者             时间    天数    照片数量     人均费用  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道  2024-07-20 出发   共9天  201张照片  人均9000元   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹  2023-10-21 出发   共7天  252张照片  人均5000元   \n",
       "2                           川西游    mnzs  2024-07-17 出发  共10天   92张照片  人均6000元   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩  2024-07-28 出发  共15天  816张照片      人均元   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃  2024-07-27 出发   共7天  151张照片      人均元   \n",
       "...                         ...     ...            ...   ...     ...      ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋  2019-07-13 出发   共5天  122张照片  人均4000元   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲  2019-07-21 出发   共9天   90张照片  人均2300元   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵  2019-02-28 出发   共1天  269张照片      人均元   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君  2019-07-13 出发   共5天  244张照片  人均4000元   \n",
       "1999                       游武夷山      珊珊  2016-09-23 出发   共3天   36张照片      人均元   \n",
       "\n",
       "        人物                        玩法                途经  \\\n",
       "0       亲子              自驾 暑假 摄影 第一次                     \n",
       "1       闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  途经：泰国(曼谷Bangkok)   \n",
       "2       家庭                  美食 自驾 暑假     途经：成都>都江堰>九寨沟   \n",
       "3       家庭                  古镇 自驾 暑假                     \n",
       "4       亲子              深度游 环游 美食 暑假                     \n",
       "...    ...                       ...               ...   \n",
       "1995  三五好友            漫游 美食 古镇 摄影 夏季    途经：杭州>绍兴>嘉兴>湖州   \n",
       "1996    家庭               海滨海岛 暑假 第一次             途经：大连   \n",
       "1997    家庭                        古镇                     \n",
       "1998  三五好友                  自驾 暑假 摄影    途经：宁波>温州>舟山>台州   \n",
       "1999    家庭                      短途周末                     \n",
       "\n",
       "                                                    行程  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                     图1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                     图2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns=[\"标题\",\"作者\",\"时间\",\"天数\",\"照片数量\",\"人均费用\",\"人物\",\"玩法\",\"途经\",\"行程\",\"图1\",\"图2\",\"图3\",\"图4\"]\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "84978637",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>标题</th>\n",
       "      <th>作者</th>\n",
       "      <th>时间</th>\n",
       "      <th>天数</th>\n",
       "      <th>照片数量</th>\n",
       "      <th>人均费用</th>\n",
       "      <th>人物</th>\n",
       "      <th>玩法</th>\n",
       "      <th>途经</th>\n",
       "      <th>行程</th>\n",
       "      <th>图1</th>\n",
       "      <th>图2</th>\n",
       "      <th>图3</th>\n",
       "      <th>图4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>人均9000元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>人均5000元</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>途经：泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>人均6000元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>途经：成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>途经：杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>人均2300元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>途经：大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>途经：宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             标题      作者         时间    天数    照片数量     人均费用  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道 2024-07-20   共9天  201张照片  人均9000元   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹 2023-10-21   共7天  252张照片  人均5000元   \n",
       "2                           川西游    mnzs 2024-07-17  共10天   92张照片  人均6000元   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩 2024-07-28  共15天  816张照片      人均元   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃 2024-07-27   共7天  151张照片      人均元   \n",
       "...                         ...     ...        ...   ...     ...      ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋 2019-07-13   共5天  122张照片  人均4000元   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲 2019-07-21   共9天   90张照片  人均2300元   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵 2019-02-28   共1天  269张照片      人均元   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君 2019-07-13   共5天  244张照片  人均4000元   \n",
       "1999                       游武夷山      珊珊 2016-09-23   共3天   36张照片      人均元   \n",
       "\n",
       "        人物                        玩法                途经  \\\n",
       "0       亲子              自驾 暑假 摄影 第一次                     \n",
       "1       闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  途经：泰国(曼谷Bangkok)   \n",
       "2       家庭                  美食 自驾 暑假     途经：成都>都江堰>九寨沟   \n",
       "3       家庭                  古镇 自驾 暑假                     \n",
       "4       亲子              深度游 环游 美食 暑假                     \n",
       "...    ...                       ...               ...   \n",
       "1995  三五好友            漫游 美食 古镇 摄影 夏季    途经：杭州>绍兴>嘉兴>湖州   \n",
       "1996    家庭               海滨海岛 暑假 第一次             途经：大连   \n",
       "1997    家庭                        古镇                     \n",
       "1998  三五好友                  自驾 暑假 摄影    途经：宁波>温州>舟山>台州   \n",
       "1999    家庭                      短途周末                     \n",
       "\n",
       "                                                    行程  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                     图1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                     图2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def get_only_start_day(start_day):\n",
    "    start_day = str(start_day)\n",
    "    start_day = start_day.replace(\" 出发\", \"\")\n",
    "    date_format = \"%Y-%m-%d\"\n",
    "    return pd.to_datetime(start_day, format=date_format, errors='coerce')\n",
    "data[\"时间\"] = data[\"时间\"].astype(str).apply(get_only_start_day)\n",
    "data_new=data\n",
    "data_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7a37b4dd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>标题</th>\n",
       "      <th>作者</th>\n",
       "      <th>时间</th>\n",
       "      <th>天数</th>\n",
       "      <th>照片数量</th>\n",
       "      <th>人均费用</th>\n",
       "      <th>人物</th>\n",
       "      <th>玩法</th>\n",
       "      <th>途经</th>\n",
       "      <th>行程</th>\n",
       "      <th>图1</th>\n",
       "      <th>图2</th>\n",
       "      <th>图3</th>\n",
       "      <th>图4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>人均9000元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>人均5000元</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>人均6000元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>人均2300元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>人均4000元</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>人均元</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             标题      作者         时间    天数    照片数量     人均费用  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道 2024-07-20   共9天  201张照片  人均9000元   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹 2023-10-21   共7天  252张照片  人均5000元   \n",
       "2                           川西游    mnzs 2024-07-17  共10天   92张照片  人均6000元   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩 2024-07-28  共15天  816张照片      人均元   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃 2024-07-27   共7天  151张照片      人均元   \n",
       "...                         ...     ...        ...   ...     ...      ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋 2019-07-13   共5天  122张照片  人均4000元   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲 2019-07-21   共9天   90张照片  人均2300元   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵 2019-02-28   共1天  269张照片      人均元   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君 2019-07-13   共5天  244张照片  人均4000元   \n",
       "1999                       游武夷山      珊珊 2016-09-23   共3天   36张照片      人均元   \n",
       "\n",
       "        人物                        玩法             途经  \\\n",
       "0       亲子              自驾 暑假 摄影 第一次                  \n",
       "1       闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  泰国(曼谷Bangkok)   \n",
       "2       家庭                  美食 自驾 暑假     成都>都江堰>九寨沟   \n",
       "3       家庭                  古镇 自驾 暑假                  \n",
       "4       亲子              深度游 环游 美食 暑假                  \n",
       "...    ...                       ...            ...   \n",
       "1995  三五好友            漫游 美食 古镇 摄影 夏季    杭州>绍兴>嘉兴>湖州   \n",
       "1996    家庭               海滨海岛 暑假 第一次             大连   \n",
       "1997    家庭                        古镇                  \n",
       "1998  三五好友                  自驾 暑假 摄影    宁波>温州>舟山>台州   \n",
       "1999    家庭                      短途周末                  \n",
       "\n",
       "                                                    行程  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                     图1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                     图2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_new[\"途经\"] = data_new[\"途经\"].str.replace(\"途经：\", \"\", regex=False).str.strip()\n",
    "data_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "956fdb5f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>标题</th>\n",
       "      <th>作者</th>\n",
       "      <th>时间</th>\n",
       "      <th>天数</th>\n",
       "      <th>照片数量</th>\n",
       "      <th>人均费用</th>\n",
       "      <th>人物</th>\n",
       "      <th>玩法</th>\n",
       "      <th>途经</th>\n",
       "      <th>行程</th>\n",
       "      <th>图1</th>\n",
       "      <th>图2</th>\n",
       "      <th>图3</th>\n",
       "      <th>图4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>2300.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>NaN</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             标题      作者         时间    天数    照片数量    人均费用  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道 2024-07-20   共9天  201张照片  9000.0   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹 2023-10-21   共7天  252张照片  5000.0   \n",
       "2                           川西游    mnzs 2024-07-17  共10天   92张照片  6000.0   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩 2024-07-28  共15天  816张照片     NaN   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃 2024-07-27   共7天  151张照片     NaN   \n",
       "...                         ...     ...        ...   ...     ...     ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋 2019-07-13   共5天  122张照片  4000.0   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲 2019-07-21   共9天   90张照片  2300.0   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵 2019-02-28   共1天  269张照片     NaN   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君 2019-07-13   共5天  244张照片  4000.0   \n",
       "1999                       游武夷山      珊珊 2016-09-23   共3天   36张照片     NaN   \n",
       "\n",
       "        人物                        玩法             途经  \\\n",
       "0       亲子              自驾 暑假 摄影 第一次                  \n",
       "1       闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  泰国(曼谷Bangkok)   \n",
       "2       家庭                  美食 自驾 暑假     成都>都江堰>九寨沟   \n",
       "3       家庭                  古镇 自驾 暑假                  \n",
       "4       亲子              深度游 环游 美食 暑假                  \n",
       "...    ...                       ...            ...   \n",
       "1995  三五好友            漫游 美食 古镇 摄影 夏季    杭州>绍兴>嘉兴>湖州   \n",
       "1996    家庭               海滨海岛 暑假 第一次             大连   \n",
       "1997    家庭                        古镇                  \n",
       "1998  三五好友                  自驾 暑假 摄影    宁波>温州>舟山>台州   \n",
       "1999    家庭                      短途周末                  \n",
       "\n",
       "                                                    行程  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                     图1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                     图2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "def get_avg_money(str_avg_money):\n",
    "    cleaned_str = str_avg_money.replace(\" 人均\", \"\").replace(\"元\", \"\")\n",
    "\n",
    "    match = re.search(r'\\d+', cleaned_str)\n",
    "    if match:\n",
    "        return int(match.group())\n",
    "    else:\n",
    "        return None\n",
    "\n",
    "\n",
    "data_new[\"人均费用\"] = data_new[\"人均费用\"].apply(get_avg_money)\n",
    "\n",
    "data_now=data_new\n",
    "data_now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8003f2fe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>标题</th>\n",
       "      <th>作者</th>\n",
       "      <th>时间</th>\n",
       "      <th>天数</th>\n",
       "      <th>照片数量</th>\n",
       "      <th>人均费用</th>\n",
       "      <th>人物</th>\n",
       "      <th>玩法</th>\n",
       "      <th>途经</th>\n",
       "      <th>行程</th>\n",
       "      <th>图1</th>\n",
       "      <th>图2</th>\n",
       "      <th>图3</th>\n",
       "      <th>图4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>你与世界的距离，只差一场说走就走的旅行——新疆行</td>\n",
       "      <td>第五大道</td>\n",
       "      <td>2024-07-20</td>\n",
       "      <td>共9天</td>\n",
       "      <td>201张照片</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>亲子</td>\n",
       "      <td>自驾 暑假 摄影 第一次</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食</td>\n",
       "      <td>马铃薯妹妹</td>\n",
       "      <td>2023-10-21</td>\n",
       "      <td>共7天</td>\n",
       "      <td>252张照片</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>闺蜜</td>\n",
       "      <td>深度游 购物 美食 短途周末 摄影 探险 第一次</td>\n",
       "      <td>泰国(曼谷Bangkok)</td>\n",
       "      <td>行程：唐人街&gt;金山寺&gt;吉姆·汤普森之家&gt;曼谷艺术文化中心&gt;湄南河&gt;大皇宫&gt;曼谷国家美术馆...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>川西游</td>\n",
       "      <td>mnzs</td>\n",
       "      <td>2024-07-17</td>\n",
       "      <td>共10天</td>\n",
       "      <td>92张照片</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>美食 自驾 暑假</td>\n",
       "      <td>成都&gt;都江堰&gt;九寨沟</td>\n",
       "      <td>行程：宽窄巷子&gt;春熙路&gt;青城山&gt;青城后山&gt;九寨沟沟口&gt;九寨沟风景区&gt;成都大熊猫繁育研究基</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>我的自驾：小众大美----2024皖滇长线</td>\n",
       "      <td>有你才精彩</td>\n",
       "      <td>2024-07-28</td>\n",
       "      <td>共15天</td>\n",
       "      <td>816张照片</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇 自驾 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>哈尔滨/延吉/长春 东北7天自由行</td>\n",
       "      <td>Joy妃</td>\n",
       "      <td>2024-07-27</td>\n",
       "      <td>共7天</td>\n",
       "      <td>151张照片</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>亲子</td>\n",
       "      <td>深度游 环游 美食 暑假</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>漫游浙江，美景与美食一网打尽</td>\n",
       "      <td>樱殇之恋</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>122张照片</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>漫游 美食 古镇 摄影 夏季</td>\n",
       "      <td>杭州&gt;绍兴&gt;嘉兴&gt;湖州</td>\n",
       "      <td>行程：西湖风景名胜区&gt;中国杭帮菜博物馆&gt;安昌古镇&gt;湘湖&gt;京杭大运河杭州景区&gt;白堤&gt;平湖秋...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019暑假大连亲子6日游</td>\n",
       "      <td>哲哲哲哲哲哲</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>共9天</td>\n",
       "      <td>90张照片</td>\n",
       "      <td>2300.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>海滨海岛 暑假 第一次</td>\n",
       "      <td>大连</td>\n",
       "      <td>行程：星海广场&gt;机场&gt;友好广场&gt;金石滩度假区&gt;老妈菜馆&gt;夏家河子海滨公园&gt;俄罗斯风情街...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>从苏州古镇到日本，一路收获快落</td>\n",
       "      <td>李小非喵喵</td>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>共1天</td>\n",
       "      <td>269张照片</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>古镇</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州</td>\n",
       "      <td>阿拖施晓君</td>\n",
       "      <td>2019-07-13</td>\n",
       "      <td>共5天</td>\n",
       "      <td>244张照片</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>三五好友</td>\n",
       "      <td>自驾 暑假 摄影</td>\n",
       "      <td>宁波&gt;温州&gt;舟山&gt;台州</td>\n",
       "      <td>行程：天一阁博物院&gt;江心屿&gt;石浦海味饭店(月湖店)&gt;蚝翅·海鲜烧烤(月湖盛园店)&gt;三毛祖居...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>游武夷山</td>\n",
       "      <td>珊珊</td>\n",
       "      <td>2016-09-23</td>\n",
       "      <td>共3天</td>\n",
       "      <td>36张照片</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>家庭</td>\n",
       "      <td>短途周末</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2000 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             标题      作者         时间    天数    照片数量    人均费用  \\\n",
       "0      你与世界的距离，只差一场说走就走的旅行——新疆行    第五大道 2024-07-20   共9天  201张照片  9000.0   \n",
       "1        曼谷·巡礼季：社畜撒欢不搬砖 追星打卡恰美食   马铃薯妹妹 2023-10-21   共7天  252张照片  5000.0   \n",
       "2                           川西游    mnzs 2024-07-17  共10天   92张照片  6000.0   \n",
       "3         我的自驾：小众大美----2024皖滇长线   有你才精彩 2024-07-28  共15天  816张照片  3000.0   \n",
       "4             哈尔滨/延吉/长春 东北7天自由行    Joy妃 2024-07-27   共7天  151张照片  3000.0   \n",
       "...                         ...     ...        ...   ...     ...     ...   \n",
       "1995             漫游浙江，美景与美食一网打尽    樱殇之恋 2019-07-13   共5天  122张照片  4000.0   \n",
       "1996              2019暑假大连亲子6日游  哲哲哲哲哲哲 2019-07-21   共9天   90张照片  2300.0   \n",
       "1997            从苏州古镇到日本，一路收获快落   李小非喵喵 2019-02-28   共1天  269张照片  3000.0   \n",
       "1998  自驾鱼米之乡，浙里有点意思：宁波-舟山-台州-温州   阿拖施晓君 2019-07-13   共5天  244张照片  4000.0   \n",
       "1999                       游武夷山      珊珊 2016-09-23   共3天   36张照片  3000.0   \n",
       "\n",
       "        人物                        玩法             途经  \\\n",
       "0       亲子              自驾 暑假 摄影 第一次                  \n",
       "1       闺蜜  深度游 购物 美食 短途周末 摄影 探险 第一次  泰国(曼谷Bangkok)   \n",
       "2       家庭                  美食 自驾 暑假     成都>都江堰>九寨沟   \n",
       "3       家庭                  古镇 自驾 暑假                  \n",
       "4       亲子              深度游 环游 美食 暑假                  \n",
       "...    ...                       ...            ...   \n",
       "1995  三五好友            漫游 美食 古镇 摄影 夏季    杭州>绍兴>嘉兴>湖州   \n",
       "1996    家庭               海滨海岛 暑假 第一次             大连   \n",
       "1997    家庭                        古镇                  \n",
       "1998  三五好友                  自驾 暑假 摄影    宁波>温州>舟山>台州   \n",
       "1999    家庭                      短途周末                  \n",
       "\n",
       "                                                    行程  \\\n",
       "0                                                        \n",
       "1      行程：唐人街>金山寺>吉姆·汤普森之家>曼谷艺术文化中心>湄南河>大皇宫>曼谷国家美术馆...   \n",
       "2         行程：宽窄巷子>春熙路>青城山>青城后山>九寨沟沟口>九寨沟风景区>成都大熊猫繁育研究基   \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                ...   \n",
       "1995   行程：西湖风景名胜区>中国杭帮菜博物馆>安昌古镇>湘湖>京杭大运河杭州景区>白堤>平湖秋...   \n",
       "1996    行程：星海广场>机场>友好广场>金石滩度假区>老妈菜馆>夏家河子海滨公园>俄罗斯风情街...   \n",
       "1997                                                     \n",
       "1998  行程：天一阁博物院>江心屿>石浦海味饭店(月湖店)>蚝翅·海鲜烧烤(月湖盛园店)>三毛祖居...   \n",
       "1999                                                     \n",
       "\n",
       "                                                     图1  \\\n",
       "0     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "4     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "\n",
       "                                                     图2  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图3  \\\n",
       "0                                                         \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...   \n",
       "3                                                         \n",
       "4                                                         \n",
       "...                                                 ...   \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...   \n",
       "1997                                                      \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...   \n",
       "1999                                                      \n",
       "\n",
       "                                                     图4  \n",
       "0                                                        \n",
       "1     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "2     https://tr-osdcp.qunarzz.com/tr_osd_tr_hy/tr-o...  \n",
       "3                                                        \n",
       "4                                                        \n",
       "...                                                 ...  \n",
       "1995  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1996  https://tr-osdcp.qunarzz.com/tr-osd-tr-mapi/im...  \n",
       "1997                                                     \n",
       "1998  https://tr-osdcp.qunarzz.com/tr-osd-tr-space/i...  \n",
       "1999                                                     \n",
       "\n",
       "[2000 rows x 14 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_now.fillna({\"人均费用\":3000},inplace=True)\n",
    "data_now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5d54355c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "人物\n",
       "三五好友    691\n",
       "亲子      216\n",
       "学生       11\n",
       "家庭      412\n",
       "情侣      257\n",
       "独自一人    287\n",
       "闺蜜      126\n",
       "Name: 人物, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "people_df = data_now.groupby(\"人物\")[\"人物\"].count()\n",
    "people_df.columns=[\"类型\",\"counts\"]\n",
    "people_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "14c820e3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f3515db8",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_now.groupby(\"人均费用\")[\"人均费用\"].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "12a51d18",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_now[\"月份\"]=data_now[\"时间\"].dt.month\n",
    "data_now[\"年\"]=data_now[\"时间\"].dt.year\n",
    "data_now"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "517565db",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_now.groupby(\"年\")[\"年\"].count()\n",
    "data_now[\"年\"].unique().tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8e61c1aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Bar\n",
    "from pyecharts.faker import Faker\n",
    "\n",
    "x_data = data_now[\"年\"].unique().tolist()\n",
    "\n",
    "y_data = data_now.groupby(\"年\")[\"年\"].count().tolist()\n",
    "c = (\n",
    "    Bar()\n",
    "    .add_xaxis(x_data)\n",
    "    .add_yaxis(\"年份\", y_data)\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(title=\"出发日期——年\"),\n",
    "        datazoom_opts=opts.DataZoomOpts(),\n",
    "    )\n",
    "\n",
    ")\n",
    "c.render(\"bar_datazoom_slider.html\")\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4dc667fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_now.groupby(\"月份\")[\"月份\"].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5541d50e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Bar\n",
    "from pyecharts.faker import Faker\n",
    "\n",
    "x_data = data_now[\"月份\"].unique().tolist()\n",
    "\n",
    "y_data = data_now.groupby(\"月份\")[\"月份\"].count().tolist()\n",
    "c = (\n",
    "    Bar()\n",
    "    .add_xaxis(x_data)\n",
    "    .add_yaxis(\"月份\", y_data)\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(title=\"出发日期——月\"),\n",
    "        datazoom_opts=opts.DataZoomOpts(),\n",
    "    )\n",
    "\n",
    ")\n",
    "c.render(\"bar_datazoom_month.html\")\n",
    "c.render_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d6480198",
   "metadata": {},
   "outputs": [],
   "source": [
    "monthly_person_counts = data_now.groupby([\"月份\", \"人物\"]).size().reset_index(name='counts')\n",
    "\n",
    "most_frequent_person_per_month = (\n",
    "    monthly_person_counts\n",
    "    .groupby(\"月份\")\n",
    "    .apply(lambda x: x[x['counts'] == x['counts'].max()][['人物', 'counts']])\n",
    "    .reset_index(level=1, drop=True)\n",
    "    .reset_index()\n",
    ")\n",
    "most_frequent_person_per_month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1c72c5fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "monthly_person_counts = data_now.groupby([\"月份\", \"人物\"]).size().reset_index(name='counts')\n",
    "\n",
    "least_frequent_person_per_month = (\n",
    "    monthly_person_counts\n",
    "    .groupby(\"月份\")\n",
    "    .apply(lambda x: x[x['counts'] == x['counts'].min()][['人物', 'counts']])\n",
    "    .reset_index(level=1, drop=True)\n",
    "    .reset_index()\n",
    ")\n",
    "least_frequent_person_per_month\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c3e0aefa",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts.charts import Bar\n",
    "from pyecharts.faker import Faker\n",
    "from pyecharts.globals import ThemeType\n",
    "\n",
    "c = (\n",
    "    Bar({\"theme\": ThemeType.MACARONS})\n",
    "    .add_xaxis(Faker.choose())\n",
    "    .add_yaxis(\"商家A\", Faker.values())\n",
    "    .add_yaxis(\"商家B\", Faker.values())\n",
    "    .set_global_opts(\n",
    "        title_opts={\"text\": \"Bar-通过 dict 进行配置\", \"subtext\": \"我也是通过 dict 进行配置的\"}\n",
    "    )\n",
    "    .render(\"bar_base_dict_config.html\")\n",
    ")\n",
    "c.render_notebook()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a0b063b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=data_now\n",
    "df_adrr = df.dropna(subset=['途经'])\n",
    "\n",
    "adrr_dic = {}\n",
    "for addr in df_adrr['途经'].tolist():\n",
    "    addr = addr.replace('...','')\n",
    "    for subadd in addr.split('>'):\n",
    "        adrr_dic[subadd] = adrr_dic.get(subadd,0)+1\n",
    "adrr_dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "28fc32ac",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5be6b120",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "42ba0abc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
